StudentEnrollmentPeriodFee

EntityType | Independent
Logical Entity Name | StudentEnrollmentPeriodFee
Default Table Name | AdFees
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentEnrollmentPeriodFee Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
StudentId |  | INTEGER | YES |
BillingTransactionCodeId |  | INTEGER | NO |
AcademicYearSequence |  | NUMERIC(3, 0) | NO |
FeeDescription |  | VARCHAR(35) | NO |
ModFlag |  | CHAR(1) | NO |
Amount |  | MONEY(19, 4) | NO |
IsOneTimeFee |  | BIT | NO |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
StudentEnrollmentPeriodFeeId |  | INTEGER | NO |
StudentEnrollmentPeriodId |  | INTEGER | NO |
TermId |  | INTEGER | YES |
IsBilled |  | BIT | NO |
TermSequence |  | NUMERIC(9, 0) | NO |
RevenueUnits |  | MONEY(19, 4) | YES |
Offset |  | INTEGER | YES |
ProgramFeeId |  | INTEGER | YES |
StudentEnrollmentPeriodId |  | INTEGER | YES |

StudentEnrollmentPeriodFee Keys

Key Name | Key Type | Keys
NK_AdFeesBilled | Inversion Entry | IsBilled
AdFees_adProgramFeeId_N_N_IDX | Inversion Entry | ProgramFeeId
AdFees_AdEnrollID_Amount_Billed_AdFeesId_AdTermId_U_N_IDX | Alternate Key | StudentEnrollmentPeriodId, Amount, IsBilled, TermId
AdFees_AdFeesID_U_C_IDX | PrimaryKey | StudentEnrollmentPeriodFeeId
AdFees_AdEnrollID_AdTermID_SaBillCodeID_AdFeesID_U_N_IDX | Alternate Key | StudentEnrollmentPeriodId, TermId, BillingTransactionCodeId

StudentEnrollmentPeriodFee Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
StudentEnrollmentPeriod | Non-Identifying | One To Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
Student | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentId | NO
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype
AutomaticBillingBatchDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentRevenueSummary | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountPendingTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransaction | Non-Identifying | Zero or One to Zero or More |  |  |  |  | NO
AutomaticBillingBatchDetail | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountPendingTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO
StudentAccountTransaction | Non-Identifying | One To Zero or More |  |  |  |  | NO

StudentEnrollmentPeriodFee Check Constraints

Check Constraint Name | CheckConstraint

StudentEnrollmentPeriodFee Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentEnrollmentPeriodFee | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdFees | NO |  |  |

StudentEnrollmentPeriodFee Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | LedgerCard_Billing
Logical | StudentEnrollment
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

StudentEnrollmentPeriodFee Data Movement Rules

Name | Type | Rule Text/Value